
INSERT INTO MSTB_INVENTORY_PERIOD
(
    ID
  , PERIOD_ID
  , PERIOD_NAME
  , START_DATE
  , END_DATE
  , OPEN_DATE_TIME
  , CLOSE_DATE_TIME
  , PERIOD_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select 
    MSSQ_INTENTORY_PERIOD_DEF_ID.nextval              as ID                
  , 201106                                            as PERIOD_ID         
  , '201106'                                          as PERIOD_NAME       
  , to_date('20110601', 'YYYYMMDD')                   as START_DATE        
  , to_date('20110630', 'YYYYMMDD')                   as END_DATE          
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as OPEN_DATE_TIME    
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as CLOSE_DATE_TIME   
  , 0                                                 as PERIOD_STATUS     
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as CREATED_TIMESTAMP 
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as MODIFIED_TIMESTAMP
from dual
;

INSERT INTO MSTB_INVENTORY_PERIOD
(
    ID
  , PERIOD_ID
  , PERIOD_NAME
  , START_DATE
  , END_DATE
  , OPEN_DATE_TIME
  , CLOSE_DATE_TIME
  , PERIOD_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select 
    MSSQ_INTENTORY_PERIOD_DEF_ID.nextval              as ID                
  , 201107                                            as PERIOD_ID         
  , '201107'                                          as PERIOD_NAME       
  , to_date('20110701', 'YYYYMMDD')                   as START_DATE        
  , to_date('20110731', 'YYYYMMDD')                   as END_DATE          
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as OPEN_DATE_TIME    
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as CLOSE_DATE_TIME   
  , 0                                                 as PERIOD_STATUS     
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as CREATED_TIMESTAMP 
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as MODIFIED_TIMESTAMP
from dual
;

INSERT INTO MSTB_INVENTORY_PERIOD
(
    ID
  , PERIOD_ID
  , PERIOD_NAME
  , START_DATE
  , END_DATE
  , OPEN_DATE_TIME
  , CLOSE_DATE_TIME
  , PERIOD_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select 
    MSSQ_INTENTORY_PERIOD_DEF_ID.nextval              as ID                
  , 201108                                            as PERIOD_ID         
  , '201108'                                          as PERIOD_NAME       
  , to_date('20110801', 'YYYYMMDD')                   as START_DATE        
  , to_date('20110831', 'YYYYMMDD')                   as END_DATE          
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as OPEN_DATE_TIME    
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as CLOSE_DATE_TIME   
  , 0                                                 as PERIOD_STATUS     
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as CREATED_TIMESTAMP 
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as MODIFIED_TIMESTAMP
from dual
;

INSERT INTO MSTB_INVENTORY_PERIOD
(
    ID
  , PERIOD_ID
  , PERIOD_NAME
  , START_DATE
  , END_DATE
  , OPEN_DATE_TIME
  , CLOSE_DATE_TIME
  , PERIOD_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select 
    MSSQ_INTENTORY_PERIOD_DEF_ID.nextval              as ID                
  , 201109                                            as PERIOD_ID         
  , '201109'                                          as PERIOD_NAME       
  , to_date('20110901', 'YYYYMMDD')                   as START_DATE          
  , to_date('20110930', 'YYYYMMDD')                   as END_DATE          
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as OPEN_DATE_TIME    
  , NULL                                              as CLOSE_DATE_TIME   
  , 1                                                 as PERIOD_STATUS     
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as CREATED_TIMESTAMP 
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as MODIFIED_TIMESTAMP
from dual
;


INSERT INTO MSTB_INVENTORY_PERIOD
(
    ID
  , PERIOD_ID
  , PERIOD_NAME
  , START_DATE
  , END_DATE
  , OPEN_DATE_TIME
  , CLOSE_DATE_TIME
  , PERIOD_STATUS
  , CREATED_TIMESTAMP
  , MODIFIED_TIMESTAMP
)
select 
    MSSQ_INTENTORY_PERIOD_DEF_ID.nextval              as ID                
  , 201110                                            as PERIOD_ID         
  , '201110'                                          as PERIOD_NAME       
  , to_date('20111001', 'YYYYMMDD')                   as START_DATE        
  , to_date('20111031', 'YYYYMMDD')                   as END_DATE          
  , to_date('20110830235959', 'YYYYMMDDHH24MISS')     as OPEN_DATE_TIME    
  , NULL                                              as CLOSE_DATE_TIME   
  , -1                                                as PERIOD_STATUS     
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as CREATED_TIMESTAMP 
  , to_date('20110901100012', 'YYYYMMDDHH24MISS')     as MODIFIED_TIMESTAMP
from dual;